- add_stock_sales_payments.php
- project /
1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20 <script type="text/javascript" src="jquery.date_input.js"></script>
21 <link rel="stylesheet" href="date_input.css" type="text/css">
22 <script type="text/javascript">$(function() {
23
24 $("#due").date_input();
25 });</script>
26
27
28 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
29 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
30 <script src="js/jquery.hotkeys-0.7.9.js"></script>
31 <!-- AJAX SUCCESS TEST FONCTION
32 <script>function callSuccessFunction(){alert("success executed")}
33 function callFailFunction(){alert("fail executed")}
34 </script>
35 -->
36
37 <script>
38
39
40 function balanceCalc()
41 { if(parseFloat($("#newpayment").val()) > parseFloat($("#balance").val()))
42 $("#newpayment").val(parseFloat($("#balance").val()));
43
44
45 }
46
47
48 $(document).ready(function() {
49 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
50 $("#name").focus();
51 $("#form1").validationEngine(),
52
53 jQuery(document).bind('keydown', 'Ctrl+s',function() {
54 $('#form1').submit();
55 return false;
56 });
57
58 jQuery(document).bind('keydown', 'Ctrl+r',function() {
59 $('#form1').reset();
60 return false;
61 });
62 jQuery(document).bind('keydown', 'Ctrl+a',function() {
63 window.location = "add_stock_sales_payment.php";
64 return false;
65 });
66 jQuery(document).bind('keydown', 'Ctrl+0',function() {
67 window.location = "admin.php";
68 return false;
69 });
70 jQuery(document).bind('keydown', 'Ctrl+1',function() {
71 window.location = "add_purchase.php";
72 return false;
73 });
74 jQuery(document).bind('keydown', 'Ctrl+2',function() {
75 window.location = "add_stock_sales.php";
76 return false;
77 });
78 jQuery(document).bind('keydown', 'Ctrl+3',function() {
79 window.location = "add_stock_details.php";
80 return false;
81 });
82 jQuery(document).bind('keydown', 'Ctrl+4',function() {
83 window.location = "add_category.php";
84 return false;
85 });
86 jQuery(document).bind('keydown', 'Ctrl+5',function() {
87 window.location = "add_supplier_details.php";
88 return false;
89 });
90 jQuery(document).bind('keydown', 'Ctrl+6',function() {
91 window.location = "add_customer_details.php";
92 return false;
93 });
94 jQuery(document).bind('keydown', 'Ctrl+7',function() {
95 window.location = "view_stock_entries.php";
96 return false;
97 });
98 jQuery(document).bind('keydown', 'Ctrl+8',function() {
99 window.location = "view_stock_sales.php";
100 return false;
101 });
102 jQuery(document).bind('keydown', 'Ctrl+9',function() {
103 window.location = "view_stock_details.php";
104 return false;
105 });
106 //$.validationEngine.loadValidation("#date")
107 //alert($("#formID").validationEngine({returnIsValid:true}))
108 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
109 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
110 });
111 </script>
112 <style type="text/css">
113 <!--
114 body {
115 margin-left: 0px;
116 margin-top: 0px;
117 margin-right: 0px;
118 margin-bottom: 0px;
119 background-color: #FFFFFF;
120 }
121
122 *{
123 padding: 0px;
124 margin: 0px;
125 }
126 #vertmenu {
127 font-family: Verdana, Arial, Helvetica, sans-serif;
128 font-size: 100%;
129 width: 160px;
130 padding: 0px;
131 margin: 0px;
132 }
133
134 #vertmenu h1 {
135 display: block;
136 background-color:#FF9900;
137 font-size: 90%;
138 padding: 3px 0 5px 3px;
139 border: 1px solid #000000;
140 color: #333333;
141 margin: 0px;
142 width:159px;
143 }
144
145 #vertmenu ul {
146 list-style: none;
147 margin: 0px;
148 padding: 0px;
149 border: none;
150 }
151 #vertmenu ul li {
152 margin: 0px;
153 padding: 0px;
154 }
155 #vertmenu ul li a {
156 font-size: 80%;
157 display: block;
158 border-bottom: 1px dashed #C39C4E;
159 padding: 5px 0px 2px 4px;
160 text-decoration: none;
161 color: #666666;
162 width:160px;
163 }
164
165 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
166 color: #000000;
167 background-color: #eeeeee;
168 }
169 .style1 {color: #000000}
170
171 -->
172 </style>
173 </head>
174
175 <body>
176 <table width="100%" border="0" cellspacing="0" cellpadding="0">
177 <tr>
178 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
179 <tr>
180 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
181 <tr>
182 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
183 </tr>
184 <tr>
185 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
186 <tr>
187 <td width="130" align="left" valign="top">
188
189 <br>
190
191 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
192 <table width="100%" border="0" cellspacing="0" cellpadding="0">
193 <tr>
194 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
195 </tr>
196 <tr>
197 <td align="center"> </td>
198 </tr>
199 <tr>
200 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
201 </tr>
202 <tr>
203 <td align="center"> </td>
204 </tr>
205 <tr>
206 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
207 </tr>
208 <tr>
209 <td align="center"> </td>
210 </tr>
211 <tr>
212 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
213 </tr>
214 <tr>
215 <td align="center"> </td>
216 </tr>
217 <tr>
218 <td align="center"> </td>
219 </tr>
220 <tr>
221 <td align="center"> </td>
222 </tr>
223 </table>
224
225
226
227
228
229 </td> <td height="500" align="center" valign="top">
230 <table width="100%" border="0" cellspacing="0" cellpadding="0">
231 <tr>
232 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
233 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
234 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
235 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
236 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
237 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
238 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
239 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
240 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
241 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
242 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
243 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
244 </tr>
245 </table>
246 <?php
247 if(isset($_POST['id']))
248
249 {
250
251 $id=mysql_real_escape_string($_POST['id']);
252 $balance=mysql_real_escape_string($_POST['balance']);
253 $payment=mysql_real_escape_string($_POST['payment']);
254 $customer=mysql_real_escape_string($_POST['customer']);
255 $subtotal=mysql_real_escape_string($_POST['subtotal']);
256 $newpayment=mysql_real_escape_string($_POST['newpayment']);
257 $selected_date=$_POST['due'];
258 $selected_date=strtotime( $selected_date );
259 $mysqldate = date( 'Y-m-d H:i:s', $selected_date );
260 $due=$mysqldate;
261 $balance= (int) $balance - (int) $newpayment;
262 $payment= (int) $payment + (int) $newpayment;
263 $max = $db->maxOfAll("id", "transactions");
264 $receiptid="RCPT".$max;
265 if($db->query("UPDATE stock_sales SET balance=$balance,payment=$payment,due='$due' where transactionid='$id'"))
266 {
267 $db->query("INSERT INTO transactions(type,customer,payment,balance,rid,due,subtotal,receiptid) values('sales','$customer',$newpayment,$balance,'$id','$due',$subtotal,'$receiptid')");
268 $max = $db->maxOfAll("id", "transactions");
269 echo "<br><font color=green size=+1 > [ $id ] Customer Details Updated!</font>" ;
270 echo "<script>window.open('payment_receipt_print.php?sid=$max','myNewWinsr','width=620,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no');</script>";
271 }
272 else
273 echo "<br><font color=red size=+1 >Problem in Updation !</font>" ;
274
275
276 }
277
278 ?>
279
280 <br>
281 <br>
282
283 <?php
284 if(isset($_GET['eid']))
285 $id=$_GET['eid'];
286
287 $line = $db->queryUniqueObject("SELECT * FROM stock_sales WHERE transactionid='$id'");
288 ?>
289 <form name="form1" method="post" id="form1" action="">
290 <input name="id" type="hidden" value="<?php echo $_GET['eid']; ?>">
291 <input name="subtotal" type="hidden" value="<?php echo $line->subtotal; ?>">
292 <p align="center"><strong>Add Stock Sales Customer Payment </strong></p>
293 <table width="300" border="0" cellspacing="0" cellpadding="0">
294 <tr>
295 <td width="150"> </td>
296 <td width="150"> </td>
297 </tr>
298 <tr>
299 <td width="150"> </td>
300 <td width="150"> </td>
301 </tr>
302 <tr>
303 <td width="150"> </td>
304 <td width="150"> </td>
305 </tr>
306 <tr>
307 <td width="150"> Sales ID :</td>
308 <td width="150"><input name="eid" type="text" id="eid" value="<?php echo $line->transactionid; ?>" readonly=""></td>
309 </tr>
310 <tr>
311 <td width="150"> </td>
312 <td width="150"> </td>
313 </tr>
314 <tr>
315 <td width="150">Supplier:</td>
316 <td width="150"><input name="customer" type="text" id="customer" value="<?php echo $line->customer_id; ?>" readonly=""></td>
317 </tr>
318 <tr>
319 <td width="150"> </td>
320 <td width="150"> </td>
321 </tr>
322 <tr>
323 <td width="150">Total</td>
324 <td width="150"><input name="total" type="text" id="total" value="<?php echo $line->subtotal; ?>" readonly=""></td>
325 </tr>
326 <tr>
327 <td> </td>
328 <td> </td>
329 </tr>
330 <tr>
331 <td>Paid</td>
332 <td><input name="payment" type="text" id="payment" c value="<?php echo $line->payment;?>" readonly=""></td>
333 </tr>
334 <tr>
335 <td> </td>
336 <td> </td>
337 </tr>
338 <tr>
339 <td>Balance</td>
340 <td><input name="balance" type="text" id="balance" value="<?php echo $line->balance;?>" readonly=""></td>
341 </tr>
342 <tr>
343 <td> </td>
344 <td> </td>
345 </tr>
346 <tr>
347 <td>Next Due</td>
348 <td><input name="due" type="text" id="due" value="<?php
349
350 $phpdate = strtotime( $line->due );
351
352 $phpdate = date("d-m-Y",$phpdate);
353
354 echo $phpdate;
355 ?>" ></td>
356 </tr>
357 <tr>
358 <td> </td>
359 <td> </td>
360 </tr>
361 <tr>
362 <td>New Payment </td>
363 <td><input name="newpayment" type="text" id="newpayment" class="validate[optional,custom[onlyNumber],length[0,100]] text-input" value="" onKeyUp="balanceCalc()" ></td>
364 </tr>
365 <tr>
366 <td> </td>
367 <td> </td>
368 </tr>
369 <tr>
370 <td align="right"><input type="reset" name="Reset" value="Reset"> </td>
371 <td>
372 <input type="submit" name="Submit" value="Save"></td>
373 </tr>
374 <tr>
375 <td align="center"> (Control + R) </td>
376 <td align="left"> ( Control + S ) </td>
377 </tr>
378 </table>
379 </form>
380 <br>
381 <br>
382
383 </td>
384 </tr>
385 </table>
386
387 </td>
388 </tr>
389 <tr>
390 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
391 </tr>
392 </table></td>
393 </tr>
394 </table></td>
395 </tr>
396 </table>
397
398 </body>
399 </html>
400 <?php
401 }
402 ?>